USE clothing 

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'emp_transfer') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP TABLE emp_transfer 
  END 

go 

CREATE TABLE emp_transfer 
  ( 
     etid       INT IDENTITY(1, 1) NOT NULL, 
     eid        VARCHAR(10) NOT NULL, 
     rawsection NVARCHAR(10) NOT NULL, 
     rawpost    NVARCHAR(15) NOT NULL, 
     nowsection NVARCHAR(10) NOT NULL, 
     nowpost    NVARCHAR(15) NOT NULL, 
     etdate     VARCHAR(10), 
     reason     NVARCHAR(20), 
     remark     NVARCHAR(200) 
     PRIMARY KEY CLUSTERED ( etid ASC )WITH (ignore_dup_key=OFF) ON [primary] 
  ) 
ON [primary] 

go 